package com.blog.dao.sys.sql;

public interface MenuSql {
	
	String  Muen_List_SQL="SELECT m.* from chb_menu m,chb_role r ,chb_role_menu rm  where m.id=rm.menu_id and r.id=rm.role_id and  r.id=#{roleId} and m.state=1 order by sort desc";
	
	String Muen_List_Role_Sql="SELECT * from chb_menu m where m.parentId=#{pid} and m.id in(SELECT rm.menu_id from chb_role_menu rm where rm.role_id=#{roleId}) and m.state=1 order by sort desc";
}
